package org.jeecg.modules.logistics.manage.sj_info.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.logistics.manage.sj_info.entity.QzAll;
import org.jeecg.modules.logistics.manage.sj_info.entity.SjInfo;
import org.jeecg.modules.logistics.table.cl.entity.Cl;
import org.jeecg.modules.logistics.table.hfqz.entity.Hfqz;
import org.jeecg.modules.logistics.table.ht.entity.Ht;
import org.jeecg.modules.logistics.table.hz_sj_pj.entity.HzSjPj;
import org.jeecg.modules.logistics.table.pltz.entity.Pltz;
import org.jeecg.modules.logistics.table.qzzp.entity.Qzzp;
import org.jeecg.modules.logistics.table.sj_hz_pj.entity.SjHzPj;
import org.jeecg.modules.logistics.table.tlht.entity.Tlht;
import org.jeecg.modules.logistics.table.tz.entity.Tz;
import org.jeecg.modules.logistics.table.wljd.entity.Wljd;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Description: 司机全部信息
 * @Author: 唐小尊
 * @Date:   2019-11-04
 * @Version: V1.0
 */
@Repository
public interface SjInfoMapper extends BaseMapper<SjInfo> {
    /**
     * 管理员得到一个司机User的信息
     * @param userId
     * @return
     */
    SjInfo getOneSjInfo(String userId);

    /**
     * 得到只有sjUser的List集合
     * @return
     */
    List<SjInfo> getSjInfoList();

    Integer getSjJdNum(String user_id);
    Integer getSjHpNum(String user_id);
    Integer getSjCpNum(String user_id);
    List<Cl> getSjClList(String user_id);
    List<Wljd> getSjWljdList(String user_id);
    List<Tz> getSjTzList(String user_id);
    List<Pltz> getSjPltzList(String user_id);
    List<Ht> getSjHtList(String user_id);
    List<Tlht> getSjTlhtList(String user_id);
    List<Hfqz> getSjHfqzList(String user_id);
    List<QzAll> getSjQzList(String user_id);

    List<Qzzp> getSjQzzp(String qz_id);
    List<Hfqz> getQzHf(String qz_id);

    List<HzSjPj> getSjBeiPjList(String user_id);
    List<SjHzPj> getSjPjList(String user_id);
    /**
     * 修改一个用户的状态
     */
    int putOneUserZt(@Param("userId") String userId, @Param("zt") int zt);
}
